RESORT MOUNTAIN PROPERTY LISTINGS
if($Status)
{
$s.=" AND Status='".$Status."' ";
}
if($Type)
{
$s.=" AND Type='".$Type."' ";
}
if($Location_State)
{
$s.=" AND Location_State='".$Location_State."' ";
}
if($Location_City)
{
$s.=" AND Location_City LIKE '%".str_replace(" ","%",$Location_City)."%' ";
}
if($Price=="25000")
{
$s.=" AND Price <'25001' ";
}
if($Price=="50000")
{
$s.=" AND Price BETWEEN 25001 AND 50000 ";
}
if($Price=="100000")
{
$s.=" AND Price BETWEEN 50001 AND 100000 ";
}
if($Price=="150000")
{
$s.=" AND Price BETWEEN 100001 AND 150000 ";
}
if($Price=="250000")
{
$s.=" AND Price BETWEEN 150001 AND 250000 ";
}
if($Price=="500000")
{
$s.=" AND Price BETWEEN 250001 AND 500000 ";
}
if($Price=="50001")
{
$s.=" AND Price > '500000'";
}
?>
require "manage/db_connection.php";
$dirThumb=str_replace("../","",$dirThumb);
$dirFull=str_replace("../","",$dirFull);
if(!$id AND !$s)
{
$sql="SELECT * FROM ".$prefix."_properties WHERE ".$visible." AND lType='2' ORDER BY id DESC LIMIT $x , $y";
$result=mysql_query($sql) or die("Extracting Properties Data Failed!Permanent Error: " . mysql_error()); if($result AND mysql_num_rows($result)>0) { while($row=mysql_fetch_array($result)) { ?>
=$row['Property_Name'];?> =$row['Status'];?>
=substr($row['Description'],0,200);?>
... read more.
Permanent Error: " . mysql_error()); if($result AND mysql_num_rows($result)>0) { while($row=mysql_fetch_array($result)) { ?>
=$row['Property_Name'];?> =$row['Status'];?>
=substr($row['Description'],0,200);?>
... read more.
Permanent Error: " . mysql_error()); if($result AND mysql_num_rows($result)>0) { $row=mysql_fetch_array($result); $weufywer=$row['thumb']; $poola=$row['thumb']; if(!$weufywer) $weufywer=$dieFull."noThumb.jpg"; $pics=" "; ?>
=$pics;?>
=stripslashes($row['Property_Name']);?> =$row['Status'];?>
if($row['Property_Address'])
{
?>
Address
=stripslashes($row['Property_Address']);?>
}
?>
if($row['Location_City'] AND $row['Location_State'])
{
?>
Location
=stripslashes($row['Location_City']).", ".$row['Location_State'];?>
}
?>
if($row['Lease_Type'])
{
?>
Lease Type
=$row['Lease_Type'];?>
}
?>
if($row['Size'])
{
?>
Size
=stripslashes($row['Size']);?>
}
?>
if($row['Building_Area'])
{
?>
Building Area
=stripslashes($row['Building_Area']);?>
}
?>
if($row['Zoning'])
{
?>
Zoning
=stripslashes($row['Zoning']);?>
}
?>
if($row['Type'])
{
?>
Type
=$row['Type'];?>
}
?>
if($row['Status'])
{
?>
Status
if($row['Status']=="SOLD") echo "SOLD";
else echo $row['Status'];
?>
}
?>
if($row['Price'] AND $row['Price']>0)
{
?>
if($row['Status']){
echo str_replace("For ","",$row['Status'])." ";
}
?>Price
if($row['Price']>1 AND $row['SalePrice']>1)
{
?>$=number_format($row['Price'],2);?>
$=number_format($row['SalePrice'],2);?>
You save: $=number_format(($row['Price']-$row['SalePrice']),2);?> } else if($row['Price']>1 AND $row['SalePrice']<1) { ?>$="".number_format($row['Price'],2).""?> } else { echo "Please Call!"; } ?>
}
?>
if($row['Price'] AND $row['Price']==0)
{
?>
$=number_format($row['SalePrice'],2);?>
You save: $=number_format(($row['Price']-$row['SalePrice']),2);?> } else if($row['Price']>1 AND $row['SalePrice']<1) { ?>$="".number_format($row['Price'],2).""?> } else { echo "Please Call!"; } ?>
if($row['Status'])
{
echo str_replace("For ","",$row['Status'])." ";
}
?>Price
Please Call
}
?>
DESCRIPTION
=str_replace("\r","
",stripslashes($row['Description']));?>
Contact Advertiser | Return to listings
=str_replace("\r","
",stripslashes($row['Description']));?>
Contact Advertiser | Return to listings
Permanent Error: " . mysql_error()); if($result AND mysql_num_rows($result)>0) { $total=mysql_num_rows($result); } else { $total=0; } } if($total>0) { echo "